/*河南星辰软件科技有限公司
@copyright Copyright (c) 2010~2022 All rights reserved.
*/
package cn.javaxc.crm.action.sale.contract;
import java.io.*;
import java.util.*;
import java.sql.*;
import cn.javaxc.model.base.SQL;
import cn.javaxc.model.base.SQLList;
import cn.javaxc.model.base.SQLMap;
import cn.javaxc.model.base.SQLParam;
import cn.javaxc.model.page.BatisPage;
import cn.javaxc.mvcwork.controller.web.TreeBean;
import cn.javaxc.mvcwork.util.common.CommonUtil;
import cn.javaxc.mvcwork.util.common.MapListUtil;
import cn.javaxc.mvcwork.util.helper.FrameHelper;
import cn.javaxc.mvcwork.util.helper.TreeTableHelper;
import org.springframework.beans.factory.annotation.Autowired;
import cn.javaxc.system.action.base.BaseAction;
import cn.javaxc.crm.mapper.sale.contract.SaleOfferMapper;
public class SaleOfferAction extends BaseAction
{
    @Autowired(required=false)
	private SaleOfferMapper mapper;
    /**
    合同信息
    */
    
    public Map cartogramSaleDet() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> quo=mapper.quo(params);
        SQLMap quo_emt=quo.getExistfirst();
        result.put("quo", quo_emt);
        
        return result;
    }
    /**
    合同明细页面
    */
    
    public Map publicContractdet() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> price=mapper.price(params);
        result.put("price", price);
        
        
        SQLList<SQLMap> pum=mapper.pum(params);
        result.put("pum", pum);
        
        
        SQLList<SQLMap> s_demand=mapper.s_demand(params);
        result.put("s_demand", s_demand);
        
        
        SQLList<SQLMap> s_bank=mapper.s_bank(params);
        result.put("s_bank", s_bank);
        
        
        SQLList<SQLMap> s_breakduty=mapper.s_breakduty(params);
        result.put("s_breakduty", s_breakduty);
        
        
        SQLList<SQLMap> s_pay=mapper.s_pay(params);
        result.put("s_pay", s_pay);
        
        
        SQLList<SQLMap> s_duty=mapper.s_duty(params);
        result.put("s_duty", s_duty);
        
        return result;
    }
    /**
    转入生产
    */
    
    public Map transferProduction() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> s_goods=mapper.s_goods(params);
        result.put("s_goods", s_goods);
        
        return result;
    }
    /**
    修改合同
    */
    
    public Map cartogramSaleUp() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> quo=mapper.quo(params);
        SQLMap quo_emt=quo.getExistfirst();
        result.put("quo", quo_emt);
        
        return result;
    }
    /**
    合同修改页面
    */
    
    public Map publicContractUp() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> price=mapper.price(params);
        result.put("price", price);
        
        
        SQLList<SQLMap> pum=mapper.pum(params);
        result.put("pum", pum);
        
        
        SQLList<SQLMap> s_demand=mapper.s_demand(params);
        result.put("s_demand", s_demand);
        
        
        SQLList<SQLMap> s_bank=mapper.s_bank(params);
        result.put("s_bank", s_bank);
        
        
        SQLList<SQLMap> s_breakduty=mapper.s_breakduty(params);
        result.put("s_breakduty", s_breakduty);
        
        
        SQLList<SQLMap> s_pay=mapper.s_pay(params);
        result.put("s_pay", s_pay);
        
        
        SQLList<SQLMap> s_duty=mapper.s_duty(params);
        result.put("s_duty", s_duty);
        
        return result;
    }
    /**
    笔记
    */
    
    public Map cartogramSaleNote() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> s_note=mapper.s_note(params);
        result.put("s_note", s_note);
        
        return result;
    }
    /**
    查看笔记
    */
    
    public Map viewNotes() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> t_note=mapper.t_note(params);
        SQLMap t_note_emt=t_note.getExistfirst();
        result.put("t_note", t_note_emt);
        
        return result;
    }
    /**
    修改笔记
    */
    
    public Map revisionNotes() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> t_note=mapper.t_note(params);
        SQLMap t_note_emt=t_note.getExistfirst();
        result.put("t_note", t_note_emt);
        
        return result;
    }
    /**
    转入生产修改
    */
    
    public Map transferProductionSubmit() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        mapper.transferProductionSubmit(params);
        
        return result;
    }
    /**
    修改合同修改
    */
    
    public Map cartogramSaleUpSubmit() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        int u_quo = mapper.u_quo(params);
        result.put("u_quo", u_quo);
        
        return result;
    }
    /**
    */
    
    public Map d_producenum() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        mapper.d_producenum(params);
        
        return result;
    }
    /**
    */
    
    public Map d_duty() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        mapper.d_duty(params);
        
        return result;
    }
    /**
    */
    
    public Map d_pay() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        mapper.d_pay(params);
        
        return result;
    }
    /**
    */
    
    public Map d_bank() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        mapper.d_bank(params);
        
        return result;
    }
    /**
    */
    
    public Map d_breakduty() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        mapper.d_breakduty(params);
        
        return result;
    }
    /**
    */
    
    public Map d_demand() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        mapper.d_demand(params);
        
        return result;
    }
    /**
    */
    
    public Map c_pirce() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        mapper.c_pirce(params);
        
        return result;
    }
    /**
    */
    
    public Map d_note() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        mapper.d_note(params);
        
        return result;
    }
    /**
    增加笔记修改
    */
    
    public Map addNotesSubmit() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        int i_note = mapper.i_note(params);
        result.put("i_note", i_note);
        
        return result;
    }
    /**
    修改笔记修改
    */
    
    public Map revisionNotesSubmit() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        mapper.revisionNotesSubmit(params);
        
        return result;
    }
}